inherited frmCadCidades: TfrmCadCidades
  Left = 204
  Top = 136
  Width = 686
  Height = 435
  Caption = 'Cadastro de Cidades'
  OldCreateOrder = True
  PixelsPerInch = 96
  TextHeight = 13
  inherited pgcCadastro: TcxPageControl
    Width = 678
    Height = 382
    ClientRectBottom = 377
    ClientRectRight = 673
    inherited tbsLista: TcxTabSheet
      inherited Grid: TcxGrid
        Width = 668
        Height = 332
        inherited GridDBBandedTableView2: TcxGridDBBandedTableView
          object GridDBBandedTableView2CODIGO: TcxGridDBBandedColumn
            DataBinding.FieldName = 'CODIGO'
            Position.BandIndex = 0
            Position.ColIndex = 0
            Position.RowIndex = 0
          end
          object GridDBBandedTableView2COD_IBGE: TcxGridDBBandedColumn
            DataBinding.FieldName = 'COD_IBGE'
            Position.BandIndex = 0
            Position.ColIndex = 1
            Position.RowIndex = 0
          end
          object GridDBBandedTableView2COD_IAGRO: TcxGridDBBandedColumn
            DataBinding.FieldName = 'COD_IAGRO'
            Position.BandIndex = 0
            Position.ColIndex = 2
            Position.RowIndex = 0
          end
          object GridDBBandedTableView2COD_SEFAZ: TcxGridDBBandedColumn
            DataBinding.FieldName = 'COD_SEFAZ'
            Position.BandIndex = 0
            Position.ColIndex = 3
            Position.RowIndex = 0
          end
          object GridDBBandedTableView2ESTADO: TcxGridDBBandedColumn
            DataBinding.FieldName = 'ESTADO'
            Position.BandIndex = 0
            Position.ColIndex = 4
            Position.RowIndex = 0
          end
          object GridDBBandedTableView2UF: TcxGridDBBandedColumn
            DataBinding.FieldName = 'UF'
            Position.BandIndex = 0
            Position.ColIndex = 5
            Position.RowIndex = 0
          end
          object GridDBBandedTableView2NOME: TcxGridDBBandedColumn
            DataBinding.FieldName = 'NOME'
            Position.BandIndex = 0
            Position.ColIndex = 6
            Position.RowIndex = 0
          end
        end
      end
      inherited Panel1: TPanel
        Width = 668
      end
    end
    inherited tbsEdita: TcxTabSheet
      inherited Panel2: TPanel
        Width = 668
        Height = 349
        object cxDBTextEdit1: TcxDBTextEdit
          Left = 7
          Top = 32
          DataBinding.DataField = 'CODIGO'
          DataBinding.DataSource = dsRegistro
          Enabled = False
          Style.Color = clWindow
          TabOrder = 0
          Width = 65
        end
        object edtNome: TcxDBTextEdit
          Left = 76
          Top = 32
          DataBinding.DataField = 'NOME'
          DataBinding.DataSource = dsRegistro
          Properties.CharCase = ecUpperCase
          TabOrder = 1
          Width = 437
        end
        object cxLabel2: TcxLabel
          Left = 76
          Top = 15
          Caption = 'Nome'
          Transparent = True
        end
        object cxLabel1: TcxLabel
          Left = 7
          Top = 15
          Caption = 'C'#243'digo'
          Transparent = True
        end
        object cbEstado: TcxDBLookupComboBox
          Left = 516
          Top = 32
          DataBinding.DataField = 'ESTADO'
          DataBinding.DataSource = dsRegistro
          Properties.CharCase = ecUpperCase
          Properties.KeyFieldNames = 'CODIGO'
          Properties.ListColumns = <
            item
              FieldName = 'UF'
            end>
          Properties.ListSource = DSUf
          TabOrder = 4
          Width = 81
        end
        object cxLabel6: TcxLabel
          Left = 518
          Top = 13
          Caption = 'UF'
          Transparent = True
        end
        object cxGroupBox1: TcxGroupBox
          Left = 6
          Top = 56
          Caption = 'C'#243'digos'
          TabOrder = 6
          Height = 84
          Width = 287
          object cxDBTextEdit4: TcxDBTextEdit
            Left = 187
            Top = 38
            DataBinding.DataField = 'COD_IAGRO'
            DataBinding.DataSource = dsRegistro
            Properties.CharCase = ecUpperCase
            TabOrder = 0
            Width = 82
          end
          object cxLabel5: TcxLabel
            Left = 186
            Top = 21
            Caption = 'IAGRO'
            Transparent = True
          end
          object cxDBTextEdit2: TcxDBTextEdit
            Left = 101
            Top = 38
            DataBinding.DataField = 'COD_SEFAZ'
            DataBinding.DataSource = dsRegistro
            Properties.CharCase = ecUpperCase
            TabOrder = 2
            Width = 82
          end
          object cxLabel4: TcxLabel
            Left = 100
            Top = 21
            Caption = 'SEFAZ'
            Transparent = True
          end
          object cxDBTextEdit3: TcxDBTextEdit
            Left = 15
            Top = 38
            DataBinding.DataField = 'COD_IBGE'
            DataBinding.DataSource = dsRegistro
            Properties.CharCase = ecUpperCase
            TabOrder = 4
            Width = 82
          end
          object cxLabel3: TcxLabel
            Left = 14
            Top = 21
            Caption = 'IBGE'
            Transparent = True
          end
        end
      end
    end
  end
  inherited dsPesquisa: TDataSource
    Left = 8
    Top = 188
  end
  inherited dsRegistro: TDataSource
    Left = 56
    Top = 188
  end
  inherited dtEdit: TIBDataSet
    DeleteSQL.Strings = (
      'delete from cidades'
      'where'
      '  CODIGO = :OLD_CODIGO')
    InsertSQL.Strings = (
      'insert into cidades'
      '  (COD_IAGRO, COD_IBGE, COD_SEFAZ, CODIGO, ESTADO, NOME)'
      'values'
      '  (:COD_IAGRO, :COD_IBGE, :COD_SEFAZ, :CODIGO, :ESTADO, :NOME)')
    RefreshSQL.Strings = (
      'Select * '
      'from cidades '
      'where'
      '  CODIGO = :CODIGO')
    SelectSQL.Strings = (
      'SELECT c.* FROM cidades c'
      'WHERE  c.codigo = :codigo')
    ModifySQL.Strings = (
      'update cidades'
      'set'
      '  COD_IAGRO = :COD_IAGRO,'
      '  COD_IBGE = :COD_IBGE,'
      '  COD_SEFAZ = :COD_SEFAZ,'
      '  CODIGO = :CODIGO,'
      '  ESTADO = :ESTADO,'
      '  NOME = :NOME'
      'where'
      '  CODIGO = :OLD_CODIGO')
    GeneratorField.Field = 'CODIGO'
    GeneratorField.Generator = 'GEN_CIDADES_ID'
    GeneratorField.ApplyEvent = gamOnPost
    Left = 56
    Top = 148
    object dtEditCODIGO: TIntegerField
      FieldName = 'CODIGO'
      Origin = '"CIDADES"."CODIGO"'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtEditCOD_IBGE: TIBStringField
      FieldName = 'COD_IBGE'
      Origin = '"CIDADES"."COD_IBGE"'
      Size = 10
    end
    object dtEditCOD_IAGRO: TIBStringField
      FieldName = 'COD_IAGRO'
      Origin = '"CIDADES"."COD_IAGRO"'
      Size = 10
    end
    object dtEditCOD_SEFAZ: TIBStringField
      FieldName = 'COD_SEFAZ'
      Origin = '"CIDADES"."COD_SEFAZ"'
      Size = 10
    end
    object dtEditNOME: TIBStringField
      FieldName = 'NOME'
      Origin = '"CIDADES"."NOME"'
      Size = 50
    end
    object dtEditESTADO: TIntegerField
      FieldName = 'ESTADO'
      Origin = '"CIDADES"."ESTADO"'
    end
  end
  inherited dtList: TIBQuery
    SQL.Strings = (
      'select c.*, e.uf from cidades c'
      'left join estados e on (e.codigo = c.estado)')
    Left = 8
    Top = 148
    object dtListCODIGO: TIntegerField
      DisplayLabel = 'C'#243'digo'
      FieldName = 'CODIGO'
      Origin = '"CIDADES"."CODIGO"'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object dtListCOD_IBGE: TIBStringField
      DisplayLabel = 'C'#243'd. IBGE'
      FieldName = 'COD_IBGE'
      Origin = '"CIDADES"."COD_IBGE"'
      Size = 10
    end
    object dtListCOD_IAGRO: TIBStringField
      DisplayLabel = 'C'#243'd. IAGRO'
      FieldName = 'COD_IAGRO'
      Origin = '"CIDADES"."COD_IAGRO"'
      Size = 10
    end
    object dtListCOD_SEFAZ: TIBStringField
      DisplayLabel = 'C'#243'd. SEFAZ'
      FieldName = 'COD_SEFAZ'
      Origin = '"CIDADES"."COD_SEFAZ"'
      Size = 10
    end
    object dtListESTADO: TIntegerField
      DisplayLabel = 'UF'
      FieldName = 'ESTADO'
      Origin = '"CIDADES"."ESTADO"'
    end
    object dtListUF: TIBStringField
      FieldName = 'UF'
      Origin = '"ESTADOS"."UF"'
      FixedChar = True
      Size = 2
    end
    object dtListNOME: TIBStringField
      DisplayLabel = 'Nome'
      FieldName = 'NOME'
      Origin = '"CIDADES"."NOME"'
      Size = 50
    end
  end
  inherited dxBarManager: TdxBarManager
    Categories.ItemsVisibles = (
      2
      2)
    Categories.Visibles = (
      True
      True)
    Left = 176
    Top = 212
    DockControlHeights = (
      0
      0
      0
      26)
  end
  inherited ActionList1: TActionList
    Left = 352
    Top = 140
  end
  inherited dsLink: TDataSource
    Left = 32
    Top = 220
  end
  inherited cxImageList1: TcxImageList
    FormatVersion = 1
    DesignInfo = 8389000
  end
  inherited dxBarDBNavigator1: TdxBarDBNavigator
    Left = 152
    Top = 212
  end
  inherited GridPopupMenu: TcxGridPopupMenu
    Left = 456
    Top = 120
  end
  inherited SaveDialog: TSaveDialog
    Left = 206
    Top = 172
  end
  inherited ACBrEnterTab1: TACBrEnterTab
    Left = 536
    Top = 164
  end
  inherited cxPropertiesStore: TcxPropertiesStore
    Components = <
      item
        Component = ACBrEnterTab1
        Properties.Strings = (
          'AboutACBr'
          'AllowDefault'
          'EnterAsTab'
          'Name'
          'Tag')
      end
      item
        Component = Grid
        Properties.Strings = (
          'Align'
          'Anchors'
          'BevelEdges'
          'BevelInner'
          'BevelKind'
          'BevelOuter'
          'BevelWidth'
          'BorderStyle'
          'BorderWidth'
          'Constraints'
          'Cursor'
          'DragCursor'
          'DragKind'
          'DragMode'
          'DragOpening'
          'DragOpeningWaitTime'
          'Enabled'
          'Font'
          'Height'
          'HelpContext'
          'HelpKeyword'
          'HelpType'
          'Hint'
          'Left'
          'LevelTabs'
          'LookAndFeel'
          'Name'
          'ParentFont'
          'PopupMenu'
          'RootLevelOptions'
          'RootLevelStyles'
          'TabOrder'
          'TabStop'
          'Tag'
          'Top'
          'Visible'
          'Width')
      end
      item
        Component = GridDBBandedTableView1
        Properties.Strings = (
          'BackgroundBitmaps'
          'Bands'
          'DataController'
          'DateTimeHandling'
          'DragMode'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FilterBox'
          'Filtering'
          'FilterRow'
          'Name'
          'NavigatorButtons'
          'NewItemRow'
          'OptionsBehavior'
          'OptionsCustomize'
          'OptionsData'
          'OptionsSelection'
          'OptionsView'
          'PopupMenu'
          'Preview'
          'Styles'
          'Synchronization'
          'Tag')
      end
      item
        Component = GridDBBandedTableView2
        Properties.Strings = (
          'BackgroundBitmaps'
          'Bands'
          'DataController'
          'DateTimeHandling'
          'DragMode'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FilterBox'
          'Filtering'
          'FilterRow'
          'Name'
          'NavigatorButtons'
          'NewItemRow'
          'OptionsBehavior'
          'OptionsCustomize'
          'OptionsData'
          'OptionsSelection'
          'OptionsView'
          'PopupMenu'
          'Preview'
          'Styles'
          'Synchronization'
          'Tag')
      end
      item
        Component = GridDBBandedTableView2COD_IAGRO
        Properties.Strings = (
          'AlternateCaption'
          'BestFitMaxWidth'
          'Caption'
          'DataBinding'
          'DateTimeGrouping'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FooterAlignmentHorz'
          'GroupIndex'
          'GroupSummaryAlignment'
          'HeaderAlignmentHorz'
          'HeaderAlignmentVert'
          'HeaderGlyph'
          'HeaderGlyphAlignmentHorz'
          'HeaderGlyphAlignmentVert'
          'MinWidth'
          'Name'
          'Options'
          'Position'
          'Properties'
          'PropertiesClassName'
          'RepositoryItem'
          'SortIndex'
          'SortOrder'
          'Styles'
          'Summary'
          'Tag'
          'Visible'
          'VisibleForCustomization'
          'Width')
      end
      item
        Component = GridDBBandedTableView2COD_IBGE
        Properties.Strings = (
          'AlternateCaption'
          'BestFitMaxWidth'
          'Caption'
          'DataBinding'
          'DateTimeGrouping'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FooterAlignmentHorz'
          'GroupIndex'
          'GroupSummaryAlignment'
          'HeaderAlignmentHorz'
          'HeaderAlignmentVert'
          'HeaderGlyph'
          'HeaderGlyphAlignmentHorz'
          'HeaderGlyphAlignmentVert'
          'MinWidth'
          'Name'
          'Options'
          'Position'
          'Properties'
          'PropertiesClassName'
          'RepositoryItem'
          'SortIndex'
          'SortOrder'
          'Styles'
          'Summary'
          'Tag'
          'Visible'
          'VisibleForCustomization'
          'Width')
      end
      item
        Component = GridDBBandedTableView2COD_SEFAZ
        Properties.Strings = (
          'AlternateCaption'
          'BestFitMaxWidth'
          'Caption'
          'DataBinding'
          'DateTimeGrouping'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FooterAlignmentHorz'
          'GroupIndex'
          'GroupSummaryAlignment'
          'HeaderAlignmentHorz'
          'HeaderAlignmentVert'
          'HeaderGlyph'
          'HeaderGlyphAlignmentHorz'
          'HeaderGlyphAlignmentVert'
          'MinWidth'
          'Name'
          'Options'
          'Position'
          'Properties'
          'PropertiesClassName'
          'RepositoryItem'
          'SortIndex'
          'SortOrder'
          'Styles'
          'Summary'
          'Tag'
          'Visible'
          'VisibleForCustomization'
          'Width')
      end
      item
        Component = GridDBBandedTableView2CODIGO
        Properties.Strings = (
          'AlternateCaption'
          'BestFitMaxWidth'
          'Caption'
          'DataBinding'
          'DateTimeGrouping'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FooterAlignmentHorz'
          'GroupIndex'
          'GroupSummaryAlignment'
          'HeaderAlignmentHorz'
          'HeaderAlignmentVert'
          'HeaderGlyph'
          'HeaderGlyphAlignmentHorz'
          'HeaderGlyphAlignmentVert'
          'MinWidth'
          'Name'
          'Options'
          'Position'
          'Properties'
          'PropertiesClassName'
          'RepositoryItem'
          'SortIndex'
          'SortOrder'
          'Styles'
          'Summary'
          'Tag'
          'Visible'
          'VisibleForCustomization'
          'Width')
      end
      item
        Component = GridDBBandedTableView2ESTADO
        Properties.Strings = (
          'AlternateCaption'
          'BestFitMaxWidth'
          'Caption'
          'DataBinding'
          'DateTimeGrouping'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FooterAlignmentHorz'
          'GroupIndex'
          'GroupSummaryAlignment'
          'HeaderAlignmentHorz'
          'HeaderAlignmentVert'
          'HeaderGlyph'
          'HeaderGlyphAlignmentHorz'
          'HeaderGlyphAlignmentVert'
          'MinWidth'
          'Name'
          'Options'
          'Position'
          'Properties'
          'PropertiesClassName'
          'RepositoryItem'
          'SortIndex'
          'SortOrder'
          'Styles'
          'Summary'
          'Tag'
          'Visible'
          'VisibleForCustomization'
          'Width')
      end
      item
        Component = GridDBBandedTableView2NOME
        Properties.Strings = (
          'AlternateCaption'
          'BestFitMaxWidth'
          'Caption'
          'DataBinding'
          'DateTimeGrouping'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FooterAlignmentHorz'
          'GroupIndex'
          'GroupSummaryAlignment'
          'HeaderAlignmentHorz'
          'HeaderAlignmentVert'
          'HeaderGlyph'
          'HeaderGlyphAlignmentHorz'
          'HeaderGlyphAlignmentVert'
          'MinWidth'
          'Name'
          'Options'
          'Position'
          'Properties'
          'PropertiesClassName'
          'RepositoryItem'
          'SortIndex'
          'SortOrder'
          'Styles'
          'Summary'
          'Tag'
          'Visible'
          'VisibleForCustomization'
          'Width')
      end
      item
        Component = GridDBBandedTableView2UF
        Properties.Strings = (
          'AlternateCaption'
          'BestFitMaxWidth'
          'Caption'
          'DataBinding'
          'DateTimeGrouping'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'FooterAlignmentHorz'
          'GroupIndex'
          'GroupSummaryAlignment'
          'HeaderAlignmentHorz'
          'HeaderAlignmentVert'
          'HeaderGlyph'
          'HeaderGlyphAlignmentHorz'
          'HeaderGlyphAlignmentVert'
          'MinWidth'
          'Name'
          'Options'
          'Position'
          'Properties'
          'PropertiesClassName'
          'RepositoryItem'
          'SortIndex'
          'SortOrder'
          'Styles'
          'Summary'
          'Tag'
          'Visible'
          'VisibleForCustomization'
          'Width')
      end
      item
        Component = GridLevel1
        Properties.Strings = (
          'Caption'
          'FakeComponentLink1'
          'FakeComponentLink2'
          'FakeComponentLink3'
          'GridView'
          'ImageIndex'
          'MaxDetailHeight'
          'Name'
          'Options'
          'Styles'
          'Tag'
          'Visible')
      end>
    Left = 232
    Top = 132
  end
  object lstUF: TIBQuery
    Database = dmPrincipal.Database
    Transaction = dmPrincipal.Transaction
    SQL.Strings = (
      'select * from ESTADOS')
    Left = 104
    Top = 148
    object lstUFCODIGO: TIntegerField
      FieldName = 'CODIGO'
      Origin = '"ESTADOS"."CODIGO"'
      ProviderFlags = [pfInUpdate, pfInWhere, pfInKey]
      Required = True
    end
    object lstUFNOME: TIBStringField
      FieldName = 'NOME'
      Origin = '"ESTADOS"."NOME"'
      Size = 50
    end
    object lstUFUF: TIBStringField
      FieldName = 'UF'
      Origin = '"ESTADOS"."UF"'
      FixedChar = True
      Size = 2
    end
  end
  object DSUf: TDataSource
    DataSet = lstUF
    Left = 104
    Top = 188
  end
end
